<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/qq_26710805/article/details/79776897"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"Mysql授权远程登陆 - Shelter"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>Mysql授权远程登陆 - Shelter - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/qq_26710805\/article\/details\/79776897","appid":"1563894916825412","title":"Mysql\u6388\u6743\u8fdc\u7a0b\u767b\u9646 - Shelter","images":["https:\/\/img-blog.csdn.net\/20180401115813566?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180504135953274?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180401121123836?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70"],"pubDate":"2019-08-09T15:09:43"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-2eefd34acf.min.css">
        <script type="text/javascript">
        var username = "qq_26710805";
        var blog_address = "https://blog.csdn.net/qq_26710805";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/qq_26710805/article/details/79776897"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-yellow";
        // 收藏所需数据
        var articleTitle = "Mysql授权远程登陆";
        var articleDesc = "在Windows环境上操作。步骤如下：1.打开cmd窗口，登陆mysqlmysql-uroot-p1234562.使用mysql数据库usemysql3.查看结果中host一行中是否有%,如果有%，此行用户名允许远程登录。下图所示，白色框中表示允许远程登录的账号：如果没有%号的相关数据，可以使用下列方法：4.授权grantallprivi...";
        // 第四范式所需数据
        var articleTitles = "Mysql授权远程登陆 - Shelter";
        
        var nickName = "EchoShelter";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/qq_26710805/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/qq_26710805/article/details/79776897";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">Mysql授权远程登陆</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年04月01日 12:12:13</span>
                    <a class="follow-nickName" href="https://me.csdn.net/qq_26710805" target="_blank">EchoShelter</a>
                    <span class="read-count">阅读数 9051</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/qq_26710805/article/details/79776897"> https://blog.csdn.net/qq_26710805/article/details/79776897</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>在Windows环境上操作。步骤如下： <br>
1. 打开cmd窗口，登陆mysql</p>



<pre class="prettyprint"><code class=" hljs lasso">mysql <span class="hljs-attribute">-uroot</span> <span class="hljs-attribute">-p123456</span></code></pre>

<p>2.使用mysql数据库</p>



<pre class="prettyprint"><code class=" hljs rust"><span class="hljs-keyword">use</span> mysql</code></pre>

<p>3.查看结果中host一行中是否有%,如果有%，此行用户名允许远程登录。下图所示，白色框中表示允许远程登录的账号： <br>
<img src="https://img-blog.csdn.net/20180401115813566?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="这里写图片描述" title=""> <br>
如果没有%号的相关数据，可以使用下列方法： <br>
<img src="https://img-blog.csdn.net/20180504135953274?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="这里写图片描述" title=""> <br>
4.授权</p>

<pre class="prettyprint"><code class=" hljs sql"><span class="hljs-operator"><span class="hljs-keyword">grant</span> <span class="hljs-keyword">all</span> <span class="hljs-keyword">privileges</span> <span class="hljs-keyword">on</span> *.* <span class="hljs-keyword">to</span> <span class="hljs-string">'用户名'</span>@<span class="hljs-string">'%'</span> identified <span class="hljs-keyword">by</span> <span class="hljs-string">'登录密码'</span> <span class="hljs-keyword">with</span> <span class="hljs-keyword">grant</span> <span class="hljs-keyword">option</span>；
flush <span class="hljs-keyword">privileges</span>;</span></code></pre>

<p><img src="https://img-blog.csdn.net/20180401121123836?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzEwODA1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="这里写图片描述" title=""></p>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_26710805/article/details/79776897","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_26710805/article/details/79776897","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="79776897">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/lovemyself196221/article/details/79491564","strategy":"BlogCommendFromAutoMl2","index":"0"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lovemyself196221/article/details/79491564","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lovemyself196221/article/details/79491564" target="_blank" title="Mysql创建用户并授权以及开启远程访问">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>创建用户并<em>授权</em>以及开启远程访问		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lovemyself196221/article/details/79491564" target="_blank" title="Mysql创建用户并授权以及开启远程访问">
				<span class="desc oneline">一、创建用户并授权1、登录mysql　　mysql-uroot-p2、创建数据库　　createdatabasetest;//以创建test为例3、创建用户创建user01,只能本地访问　　creat...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lovemyself196221">来自：	<span class="blog_title"> 水墨青花的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_24571549/article/details/74612623","strategy":"BlogCommendFromAutoMl2","index":"1"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_24571549/article/details/74612623","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_24571549/article/details/74612623" target="_blank" title="mysql创建远程用户并授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em>创建远程用户并<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-06</span>
				<span class="read-num hover-hide">
					阅读数 
					139</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_24571549/article/details/74612623" target="_blank" title="mysql创建远程用户并授权">
				<span class="desc oneline">今天需要在本地测试系统功能，因为本地没有数据库，就需要在程序里面连接远程数据库；先用ssh登录远程服务器，用root连上数据库看看mysql&gt;selectHost,User,Passwordfromm...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_24571549">来自：	<span class="blog_title"> 山水人间。</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/horace_lee/article/details/83323488","strategy":"BlogCommendFromAutoMl2","index":"2"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/horace_lee/article/details/83323488","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/horace_lee/article/details/83323488" target="_blank" title="MySql Root 用户远程登录的解决">
		<h4 class="text-truncate oneline">
				<em>MySql</em> Root 用户远程登录的解决		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-10</span>
				<span class="read-num hover-hide">
					阅读数 
					22</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/horace_lee/article/details/83323488" target="_blank" title="MySql Root 用户远程登录的解决">
				<span class="desc oneline"> GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'youpassword'WITHGRANTOPTION;grantallondepot_develop...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/horace_lee">来自：	<span class="blog_title"> horace_lee的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/mengzuchao/article/details/80188818","strategy":"BlogCommendFromAutoMl2","index":"3"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/mengzuchao/article/details/80188818","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mengzuchao/article/details/80188818" target="_blank" title="mysql  命令连接，授权用户">
		<h4 class="text-truncate oneline">
				<em>mysql</em>  命令连接，<em>授权</em>用户		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-03</span>
				<span class="read-num hover-hide">
					阅读数 
					972</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mengzuchao/article/details/80188818" target="_blank" title="mysql  命令连接，授权用户">
				<span class="desc oneline">1. 连接命令：mysql-hc-P3306-uroot-p -h127.0.0.1:host代表主机或ip -P3306:mysql端口 -uroot:mysql用户 -p:密码2. 连接成功后，就...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mengzuchao">来自：	<span class="blog_title"> mengzuchao的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_35959613/article/details/81330909","strategy":"BlogCommendFromAutoMl2","index":"4"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_35959613/article/details/81330909","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_35959613/article/details/81330909" target="_blank" title="Mysql 授权">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-01</span>
				<span class="read-num hover-hide">
					阅读数 
					479</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_35959613/article/details/81330909" target="_blank" title="Mysql 授权">
				<span class="desc oneline">授权命令：GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'root'WITHGRANTOPTION;授权成功后进行刷新：flushprivileges;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_35959613">来自：	<span class="blog_title"> 遇见的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/weixin_38669628/11023543","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/weixin_38669628/11023543","strategy":"BlogCommendFromBaidu","index":"5"}'>
		<a href="https://download.csdn.net/download/weixin_38669628/11023543" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>mysql</em><em>授权</em>					</h4>
					<span class="data float-right">03-16</span>
				</div>
				<div class="desc oneline">
						NULL 博文链接：https://liangwang.iteye.com/blog/385623				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/yunyexiangfeng/article/details/82876964","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/yunyexiangfeng/article/details/82876964","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yunyexiangfeng/article/details/82876964" target="_blank" title="mysql8使用grant授权修改">
		<h4 class="text-truncate oneline">
				<em>mysql</em>8使用grant<em>授权</em>修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yunyexiangfeng/article/details/82876964" target="_blank" title="mysql8使用grant授权修改">
				<span class="desc oneline">在使用mysql5的时候，在linux安装完成mysql后，习惯使用grantallprivilegeson*.*to'user'@'%'；命令授权远程连接操作。最近linux安装mysql8后，再次...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yunyexiangfeng">来自：	<span class="blog_title"> yunyexiangfeng的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/m0_38068812/article/details/83019901","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/m0_38068812/article/details/83019901","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/m0_38068812/article/details/83019901" target="_blank" title="mysql  给用户授权和收回权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>  给用户<em>授权</em>和收回权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-11</span>
				<span class="read-num hover-hide">
					阅读数 
					802</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/m0_38068812/article/details/83019901" target="_blank" title="mysql  给用户授权和收回权限">
				<span class="desc oneline">一、mysql权限详解1、权限组成结构:   用户：权限的主体，一个用户拥有自己的用户名和密码，并拥有能够操作的权限；   操作权限：限制一个用户能够做什么事情，在MySQL中，操作权限可以配置到全局...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/m0_38068812">来自：	<span class="blog_title"> m0_38068812的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/shaier/article/details/2758949","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/shaier/article/details/2758949","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shaier/article/details/2758949" target="_blank" title="MySQL用户授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>用户<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-02</span>
				<span class="read-num hover-hide">
					阅读数 
					3012</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shaier/article/details/2758949" target="_blank" title="MySQL用户授权">
				<span class="desc oneline"> 来源:hi.baidu.com/lozn/blog/item/17372e348231dc395bb5f5af.htmlMySQL用户授权GRANT语句的语法如下：    GRANTprivileg...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shaier">来自：	<span class="blog_title"> shaier的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/felix_ghc/article/details/81875322","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/felix_ghc/article/details/81875322","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/felix_ghc/article/details/81875322" target="_blank" title="MySQL用户授权与访问控制">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>用户<em>授权</em>与访问控制		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-20</span>
				<span class="read-num hover-hide">
					阅读数 
					456</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/felix_ghc/article/details/81875322" target="_blank" title="MySQL用户授权与访问控制">
				<span class="desc oneline">这本来是一篇讲述怎么在Linux上完成MySQL的安装、新建用户并授权的博文，后来查阅了不少资料，看到一篇有意思的文章，思绪就开始泛滥了。mysql&amp;amp;gt;FLUSHPRIVILEGES;也许...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/felix_ghc">来自：	<span class="blog_title"> wahcheung的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ieeso/article/details/81482763","strategy":"BlogCommendFromAutoMl2","index":"10"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ieeso/article/details/81482763","strategy":"BlogCommendFromAutoMl2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ieeso/article/details/81482763" target="_blank" title="mysql给root开启远程访问权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>给root开启远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-07</span>
				<span class="read-num hover-hide">
					阅读数 
					368</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ieeso/article/details/81482763" target="_blank" title="mysql给root开启远程访问权限">
				<span class="desc oneline">本人在阿里云买了个服务器，自带mysql，感觉不能每次都通过Xshell去操作远程服务器，想尝试通过本地的sqlyog管理工具去连接，但是即使账号密码全正确，也会报错：errorno.1045acce...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ieeso">来自：	<span class="blog_title"> ieeso的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/millerrch/article/details/84613080","strategy":"BlogCommendFromAutoMl2","index":"11"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/millerrch/article/details/84613080","strategy":"BlogCommendFromAutoMl2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/millerrch/article/details/84613080" target="_blank" title="MySQL的权限">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-09</span>
				<span class="read-num hover-hide">
					阅读数 
					38</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/millerrch/article/details/84613080" target="_blank" title="MySQL的权限">
				<span class="desc oneline">一．权限表mysql数据库中的3个权限表：user 、db、 host权限表的存取过程是：1)先从user表中的host、 user、 password这3个字段中判断连接的IP、用户名、密码是否存在...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/millerrch">来自：	<span class="blog_title"> millerrch的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_34625397/article/details/80775136","strategy":"BlogCommendFromAutoMl2","index":"12"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_34625397/article/details/80775136","strategy":"BlogCommendFromAutoMl2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34625397/article/details/80775136" target="_blank" title="mysql授权用户访问权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>用户访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-22</span>
				<span class="read-num hover-hide">
					阅读数 
					2481</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34625397/article/details/80775136" target="_blank" title="mysql授权用户访问权限">
				<span class="desc oneline">GRANTpriv_typeONdatabase.tableTOuser[IDENTIFIEDBY[PASSWORD]'password'][,user[IDENTIFIEDBY[PASSWORD]'...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34625397">来自：	<span class="blog_title"> 守护大白菜的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zyddj123/article/details/80482329","strategy":"BlogCommendFromAutoMl2","index":"13"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zyddj123/article/details/80482329","strategy":"BlogCommendFromAutoMl2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zyddj123/article/details/80482329" target="_blank" title="mysql远程登录（授权与撤销授权）">
		<h4 class="text-truncate oneline">
				<em>mysql</em>远程登录（<em>授权</em>与撤销<em>授权</em>）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zyddj123/article/details/80482329" target="_blank" title="mysql远程登录（授权与撤销授权）">
				<span class="desc oneline">一、远程登录授权：GRANT1.登录musqlmysql-uroot-r2.输入密码登陆之后授权：mysql&amp;amp;amp;gt;GRANTALLPRIVILEGESON*.*TO'root'@'%...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zyddj123">来自：	<span class="blog_title"> 清晨一场梦</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30609287/article/details/97984907","strategy":"BlogCommendFromAutoMl2","index":"14"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30609287/article/details/97984907","strategy":"BlogCommendFromAutoMl2","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30609287/article/details/97984907" target="_blank" title="mariadb自带命令行客户端指令笔记">
		<h4 class="text-truncate oneline">
				mariadb自带命令行客户端指令笔记		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-22</span>
				<span class="read-num hover-hide">
					阅读数 
					5</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30609287/article/details/97984907" target="_blank" title="mariadb自带命令行客户端指令笔记">
				<span class="desc oneline">mysql-H主机IP-u用户名-p-p表示要输密码,不要直接输了,要回车后在程序里输入显示数据库列表:showdatabases;选择XX数据库:useXX;显示数据库里的表:showtables;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30609287">来自：	<span class="blog_title"> weixin_30609287的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/330154879","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/330154879","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<a href="https://bbs.csdn.net/topics/330154879" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> grant <em>授权</em>不起作用		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-15</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">作如下授权 grant all privileges on erp.* to erp@localhost identified by 'erp' with grant option; phpwind告</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/80x88/article/details/207261","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/80x88/article/details/207261","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/80x88/article/details/207261" target="_blank" title="mysql password">
		<h4 class="text-truncate oneline">
				<em>mysql</em> password		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-07</span>
				<span class="read-num hover-hide">
					阅读数 
					2272</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/80x88/article/details/207261" target="_blank" title="mysql password">
				<span class="desc oneline">MySQL中修改密码及访问限制设置详解其实直接使用phpmyadmin直接就可以改了，我用的是2.6.0的版本来源www.enet.com.cn　　MySQL是一个真正的多用户、多线程SQL数据库服务...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/a543402496/article/details/78347349","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/a543402496/article/details/78347349","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a543402496/article/details/78347349" target="_blank" title="MySQL：创建用户并授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>：创建用户并<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-25</span>
				<span class="read-num hover-hide">
					阅读数 
					5029</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a543402496/article/details/78347349" target="_blank" title="MySQL：创建用户并授权">
				<span class="desc oneline">一,创建用户:命令:CREATEUSER'username'@'host'IDENTIFIEDBY'password';说明:username-你将创建的用户名,host-指定该用户在哪个主机上可以登...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a543402496">来自：	<span class="blog_title"> a543402496的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xinyh0453/article/details/79217617","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xinyh0453/article/details/79217617","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xinyh0453/article/details/79217617" target="_blank" title="mysql grant授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em> grant<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-31</span>
				<span class="read-num hover-hide">
					阅读数 
					646</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xinyh0453/article/details/79217617" target="_blank" title="mysql grant授权">
				<span class="desc oneline">https://www.cnblogs.com/bethal/p/5512755.html点击打开链接</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xinyh0453">来自：	<span class="blog_title"> 蜡笔小辛的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39626154/article/details/83822666","strategy":"BlogCommendFromAutoMl2","index":"19"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39626154/article/details/83822666","strategy":"BlogCommendFromAutoMl2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_39626154/article/details/83822666" target="_blank" title="MySQL添加用户、删除用户、授权及撤销权限">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>添加用户、删除用户、<em>授权</em>及撤销权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-07</span>
				<span class="read-num hover-hide">
					阅读数 
					4734</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_39626154/article/details/83822666" target="_blank" title="MySQL添加用户、删除用户、授权及撤销权限">
				<span class="desc oneline">一.创建用户：mysql&amp;amp;gt;insertintomysql.user(Host,User,Password)values(&amp;quot;localhost&amp;quot;,&amp;quot;test&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_39626154">来自：	<span class="blog_title"> 草莓甜甜圈的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ynnmnm/article/details/45097857","strategy":"BlogCommendFromAutoMl2","index":"20"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ynnmnm/article/details/45097857","strategy":"BlogCommendFromAutoMl2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ynnmnm/article/details/45097857" target="_blank" title="MySQL本地可以连接，远程连接不上的问题">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>本地可以连接，远程连接不上的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ynnmnm/article/details/45097857" target="_blank" title="MySQL本地可以连接，远程连接不上的问题">
				<span class="desc oneline">之前遇到过MySQL本地可以连接但是远程连不上的问题，没有记录，今天在ucloud云上新申请的服务器上又遇到这个问题，记录一下解决过程。1.排除网络或防火墙问题先看是否能ping通远程服务器，ping...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ynnmnm">来自：	<span class="blog_title"> 夜风的BLOG</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sahusoft/article/details/4463203","strategy":"BlogCommendFromAutoMl2","index":"21"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sahusoft/article/details/4463203","strategy":"BlogCommendFromAutoMl2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sahusoft/article/details/4463203" target="_blank" title="mysql的grant命令">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的grant命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-19</span>
				<span class="read-num hover-hide">
					阅读数 
					935</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sahusoft/article/details/4463203" target="_blank" title="mysql的grant命令">
				<span class="desc oneline">本文实例，运行于MySQL5.0及以上版本。MySQL赋予用户权限命令的简单格式可概括为：grant权限on数据库对象to用户一、grant普通数据用户，查询、插入、更新、删除数据库中所有表数据的权利...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sahusoft">来自：	<span class="blog_title"> 王以山的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangbest2009/article/details/7767672","strategy":"BlogCommendFromAutoMl2","index":"22"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangbest2009/article/details/7767672","strategy":"BlogCommendFromAutoMl2","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangbest2009/article/details/7767672" target="_blank" title="mysql 数据库授权(给某个用户授权某个数据库)">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 数据库<em>授权</em>(给某个用户<em>授权</em>某个数据库)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-20</span>
				<span class="read-num hover-hide">
					阅读数 
					4206</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangbest2009/article/details/7767672" target="_blank" title="mysql 数据库授权(给某个用户授权某个数据库)">
				<span class="desc oneline">原文链接：http://www.cnblogs.com/jifeng/archive/2011/03/06/1972183.html 先设置该用户只有showdatabase权限grantselect...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangbest2009">来自：	<span class="blog_title"> 叮咚侠的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43714335/article/details/84169093","strategy":"BlogCommendFromAutoMl2","index":"23"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_43714335/article/details/84169093","strategy":"BlogCommendFromAutoMl2","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43714335/article/details/84169093" target="_blank" title="Mysql创建用户与授权，限制IP">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>创建用户与<em>授权</em>，限制IP		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-17</span>
				<span class="read-num hover-hide">
					阅读数 
					952</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43714335/article/details/84169093" target="_blank" title="Mysql创建用户与授权，限制IP">
				<span class="desc oneline">1.创建用户CREATEUSER'dog'@'localhost'IDENTIFIEDBY'123456';CREATEUSER‘用户名’@‘限制的IP地址’IDENTIFIEDBY‘密码’;2.授权...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43714335">来自：	<span class="blog_title"> weixin_43714335的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Leewuyang_520/article/details/25986597","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Leewuyang_520/article/details/25986597","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Leewuyang_520/article/details/25986597" target="_blank" title="org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection">
		<h4 class="text-truncate oneline">
				org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-16</span>
				<span class="read-num hover-hide">
					阅读数 
					7万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Leewuyang_520/article/details/25986597" target="_blank" title="org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection">
				<span class="desc oneline">org.apache.ibatis.exceptions.PersistenceException:###Errorqueryingdatabase.Cause:org.springframework...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Leewuyang_520">来自：	<span class="blog_title"> 李武杨</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wb175208/article/details/78519481","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wb175208/article/details/78519481","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wb175208/article/details/78519481" target="_blank" title="MySQL查看授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查看<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-13</span>
				<span class="read-num hover-hide">
					阅读数 
					4367</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wb175208/article/details/78519481" target="_blank" title="MySQL查看授权">
				<span class="desc oneline">要想查看MySQL的授权给了那些用户，以及给这些用户那些权限，可以通过一下命令来实现：查看已经授权的用户：selectuser,hostfrommysql.user;查看用户的授权权限：select*...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wb175208">来自：	<span class="blog_title"> wb175208的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/shouhou_Bingo/article/details/52607322","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/shouhou_Bingo/article/details/52607322","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shouhou_Bingo/article/details/52607322" target="_blank" title="MySQL 添加用户与授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 添加用户与<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-21</span>
				<span class="read-num hover-hide">
					阅读数 
					8071</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shouhou_Bingo/article/details/52607322" target="_blank" title="MySQL 添加用户与授权">
				<span class="desc oneline">创建用户的SQL命令：CREATEUSER 'username'@'%' IDENTIFIEDBY'password';--创建一个账号为“username”，密码为&quot;password&quot;的用户。授予用...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shouhou_Bingo">来自：	<span class="blog_title"> Bingo的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qin_jian_bo/article/details/50830459","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qin_jian_bo/article/details/50830459","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qin_jian_bo/article/details/50830459" target="_blank" title="mysql开辟新用户并授权相应权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开辟新用户并<em>授权</em>相应权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1971</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qin_jian_bo/article/details/50830459" target="_blank" title="mysql开辟新用户并授权相应权限">
				<span class="desc oneline">1.首先你需要用有root权限的账号登陆mysql(这里应该以有授权权限的账号登陆也行)2.建立一个想要授权给新账号的数据库3.执行以下语句grantallon*.*to'username'@'地址'...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qin_jian_bo">来自：	<span class="blog_title"> boboidea</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39331713/article/details/81747188","strategy":"BlogCommendFromAutoMl2","index":"28"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_39331713/article/details/81747188","strategy":"BlogCommendFromAutoMl2","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_39331713/article/details/81747188" target="_blank" title="Mysql添加用户，给用户授权">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>添加用户，给用户<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-16</span>
				<span class="read-num hover-hide">
					阅读数 
					3921</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_39331713/article/details/81747188" target="_blank" title="Mysql添加用户，给用户授权">
				<span class="desc oneline">创建用户CREATE USER 'username'@'host' IDENTIFIED BY 'password';username–你将创建的用户名说明:host–指定该用户在哪个主机上可以登陆,...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_39331713">来自：	<span class="blog_title"> 程序猿_hw的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/a351945755/article/details/21750423","strategy":"BlogCommendFromAutoMl2","index":"29"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/a351945755/article/details/21750423","strategy":"BlogCommendFromAutoMl2","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a351945755/article/details/21750423" target="_blank" title="mysql 远程登录并授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 远程登录并<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-21</span>
				<span class="read-num hover-hide">
					阅读数 
					570</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a351945755/article/details/21750423" target="_blank" title="mysql 远程登录并授权">
				<span class="desc oneline">每次在linux下安装MYSQL后需要授权远程登录，非常麻烦，现在记录如下：  创建远程登陆用户并授权  grantallPRIVILEGESon*.*toroot@“%” identifiedby“...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a351945755">来自：	<span class="blog_title"> 明明</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/forever_insist/article/details/80871354","strategy":"BlogCommendFromAutoMl2","index":"30"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/forever_insist/article/details/80871354","strategy":"BlogCommendFromAutoMl2","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/forever_insist/article/details/80871354" target="_blank" title="mysql 账号授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 账号<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-01</span>
				<span class="read-num hover-hide">
					阅读数 
					364</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/forever_insist/article/details/80871354" target="_blank" title="mysql 账号授权">
				<span class="desc oneline">创建账户createuser用户名identifiedby‘密码’;createuserdemoidentifiedby‘123456’;默认创建的账户没有任何权限需要用下面的语句给账户授权回收mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/forever_insist">来自：	<span class="blog_title"> forever_insist的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/rcjjian/article/details/80361471","strategy":"BlogCommendFromAutoMl2","index":"31"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/rcjjian/article/details/80361471","strategy":"BlogCommendFromAutoMl2","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rcjjian/article/details/80361471" target="_blank" title="MySQL的授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-18</span>
				<span class="read-num hover-hide">
					阅读数 
					188</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rcjjian/article/details/80361471" target="_blank" title="MySQL的授权">
				<span class="desc oneline">背景  在安装Portus的时候，为Portus创建一个数据库并创建一个用户授权Portus时，当前为root最高权限用户登录，通过GRANT命令授权用户名为portus时候，却提示我没有授权的权限。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rcjjian">来自：	<span class="blog_title"> JadonYuen的学习笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/79594438","strategy":"BlogCommendFromAutoMl2","index":"32"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/79594438","strategy":"BlogCommendFromAutoMl2","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/79594438" target="_blank" title="mysql授权主机+授权用户">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>主机+<em>授权</em>用户		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1552</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wuhuagu_wuhuaguo/article/details/79594438" target="_blank" title="mysql授权主机+授权用户">
				<span class="desc oneline">一、授权用户1、以管理员身份登陆进入数据库mysql-uroot-p输入密码2、新建用户名：zs 密码：1234 的mysql用户insertintomysql.user(Host,User,Pass...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wuhuagu_wuhuaguo">来自：	<span class="blog_title"> wuhuagu_wuhuaguo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/tantexian/article/details/44861733","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/tantexian/article/details/44861733","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tantexian/article/details/44861733" target="_blank" title="mysql授权localhost&amp;%区别及一直授权错误解决办法（安装openstack有感）">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>localhost&amp;%区别及一直<em>授权</em>错误解决办法（安装openstack有感）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-03</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tantexian/article/details/44861733" target="_blank" title="mysql授权localhost&amp;%区别及一直授权错误解决办法（安装openstack有感）">
				<span class="desc oneline">首先还是附上openstack文档，以此作为例子讲解为什么赋权了%而却一直报权限错误！mysql-uroot-pyunjisuan CREATEDATABASEkeystone;GRANTALLPRI...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tantexian">来自：	<span class="blog_title"> Better Me的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30265103/article/details/97224802","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30265103/article/details/97224802","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30265103/article/details/97224802" target="_blank" title="【转】MySQL GRANT REVOKE用法">
		<h4 class="text-truncate oneline">
				【转】<em>MySQL</em> GRANT REVOKE用法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-09</span>
				<span class="read-num hover-hide">
					阅读数 
					5</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30265103/article/details/97224802" target="_blank" title="【转】MySQL GRANT REVOKE用法">
				<span class="desc oneline">MySQL的权限系统围绕着两个概念：认证-&amp;gt;确定用户是否允许连接数据库服务器授权-&amp;gt;确定用户是否拥有足够的权限执行查询请求等。如果认证不成功的话，哪么授权肯定是无法进行的。revoke跟g...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30265103">来自：	<span class="blog_title"> weixin_30265103的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/gebitan505/article/details/51726649","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/gebitan505/article/details/51726649","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gebitan505/article/details/51726649" target="_blank" title="MySQL创建用户与授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>创建用户与<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gebitan505/article/details/51726649" target="_blank" title="MySQL创建用户与授权">
				<span class="desc oneline">一.创建用户命令:CREATEUSER'username'@'host'IDENTIFIEDBY'password';说明：username：你将创建的用户名host：指定该用户在哪个主机上可以登陆，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gebitan505">来自：	<span class="blog_title"> AndyLizh的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31382921/article/details/53642499","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31382921/article/details/53642499","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_31382921/article/details/53642499" target="_blank" title="mysql 授权与回收权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>授权</em>与回收权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-14</span>
				<span class="read-num hover-hide">
					阅读数 
					4553</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_31382921/article/details/53642499" target="_blank" title="mysql 授权与回收权限">
				<span class="desc oneline">授权：授权的关键字是grant，使用grant···to···授权1.给用户授权grantallprivilegeson*.*toroot;2.给某个ip授权，使指定ip有权限访问mysql数据库gr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_31382921">来自：	<span class="blog_title"> 妙妙的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/lijpwsw/article/details/7263669","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lijpwsw/article/details/7263669","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lijpwsw/article/details/7263669" target="_blank" title="MySQL中grant命令详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中grant命令详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-16</span>
				<span class="read-num hover-hide">
					阅读数 
					510</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lijpwsw/article/details/7263669" target="_blank" title="MySQL中grant命令详解">
				<span class="desc oneline">本文实例，运行于MySQL5.0及以上版本。MySQL赋予用户权限命令的简单格式可概括为：grant权限on数据库对象to用户一、grant普通数据用户，查询、插入、更新、删除数据库中所有表数据的权利...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lijpwsw">来自：	<span class="blog_title"> WEB开发</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaolong_4_2/article/details/85281918","strategy":"BlogCommendFromAutoMl2","index":"38"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaolong_4_2/article/details/85281918","strategy":"BlogCommendFromAutoMl2","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaolong_4_2/article/details/85281918" target="_blank" title="mysql给用户授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em>给用户<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-27</span>
				<span class="read-num hover-hide">
					阅读数 
					766</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaolong_4_2/article/details/85281918" target="_blank" title="mysql给用户授权">
				<span class="desc oneline">MySQL赋予用户权限命令的简单格式可概括为：grant权限on数据库对象to用户（授权后记得刷新权限：flushprivileges;）一、grant普通数据用户，查询、插入、更新、删除数据库中所有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaolong_4_2">来自：	<span class="blog_title"> aboth的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaoshunzi111/article/details/52803663","strategy":"BlogCommendFromAutoMl2","index":"39"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaoshunzi111/article/details/52803663","strategy":"BlogCommendFromAutoMl2","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaoshunzi111/article/details/52803663" target="_blank" title="mysql 对用户授权的操作">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 对用户<em>授权</em>的操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-13</span>
				<span class="read-num hover-hide">
					阅读数 
					7968</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaoshunzi111/article/details/52803663" target="_blank" title="mysql 对用户授权的操作">
				<span class="desc oneline">grant 权限 on 数据库名.表名to用户名@'可以访问的地址'identifiedby&quot;密码&quot;     权限： all 所有权限   usage无权限  select,update,insert...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaoshunzi111">来自：	<span class="blog_title"> 似水流年</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/WeiHao0240/article/details/88878281","strategy":"BlogCommendFromAutoMl2","index":"40"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/WeiHao0240/article/details/88878281","strategy":"BlogCommendFromAutoMl2","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/WeiHao0240/article/details/88878281" target="_blank" title="MySQL远程登录授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>远程登录<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-28</span>
				<span class="read-num hover-hide">
					阅读数 
					30</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/WeiHao0240/article/details/88878281" target="_blank" title="MySQL远程登录授权">
				<span class="desc oneline">MySQL远程登录授权1.问题2.解决方案1.先用localhost登录2.执行授权命令3.退出再试3.远程登录1.问题MySQL登录时出现Accessdeniedforuser‘root’@‘xxx...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/WeiHao0240">来自：	<span class="blog_title"> Jack魏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26710805/article/details/80674006","strategy":"BlogCommendFromAutoMl2","index":"41"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26710805/article/details/80674006","strategy":"BlogCommendFromAutoMl2","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_26710805/article/details/80674006" target="_blank" title="git命令总结记录">
		<h4 class="text-truncate oneline">
				git命令总结记录		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-19</span>
				<span class="read-num hover-hide">
					阅读数 
					5万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_26710805/article/details/80674006" target="_blank" title="git命令总结记录">
				<span class="desc oneline">git分支查看命令gitbranch-a带有“*”号的表示当前分支</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_26710805">来自：	<span class="blog_title"> Shelter</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26710805/article/details/79977148","strategy":"BlogCommendFromAutoMl2","index":"42"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26710805/article/details/79977148","strategy":"BlogCommendFromAutoMl2","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_26710805/article/details/79977148" target="_blank" title="java读取src路径下的文件">
		<h4 class="text-truncate oneline">
				java读取src路径下的文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-19</span>
				<span class="read-num hover-hide">
					阅读数 
					9106</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_26710805/article/details/79977148" target="_blank" title="java读取src路径下的文件">
				<span class="desc oneline">在eclipse中建立java工程，如下所示：test.txt是需要我们读取的文件。下面读取test.txt文件packagecom.File;importjava.io.File;importjav...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_26710805">来自：	<span class="blog_title"> Shelter</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Cryhelyxx/article/details/40114695","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Cryhelyxx/article/details/40114695","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Cryhelyxx/article/details/40114695" target="_blank" title="mysql数据库远程连接授权">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库远程连接<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-15</span>
				<span class="read-num hover-hide">
					阅读数 
					7030</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Cryhelyxx/article/details/40114695" target="_blank" title="mysql数据库远程连接授权">
				<span class="desc oneline">1.本地进入mysql数据库	mysql-uroot-p123456（ps:root是用户名，123456是密码）2.mysql远程连接授权USEmysql;GRANTALLPRIVILEGESON*...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Cryhelyxx">来自：	<span class="blog_title"> zhuxiongxian的挨踢博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010440155/article/details/51944880","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010440155/article/details/51944880","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010440155/article/details/51944880" target="_blank" title="mysql 用户创建、数据库创建、数据库授权给用户问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 用户创建、数据库创建、数据库<em>授权</em>给用户问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-18</span>
				<span class="read-num hover-hide">
					阅读数 
					4996</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010440155/article/details/51944880" target="_blank" title="mysql 用户创建、数据库创建、数据库授权给用户问题">
				<span class="desc oneline">mysql-uroot-p#允许本地IP访问localhost,127.0.0.1#insertintomysql.user(Host,User,Password)values('localhost'...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010440155">来自：	<span class="blog_title"> u010440155的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/swotcoder/article/details/18518","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/swotcoder/article/details/18518","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/swotcoder/article/details/18518" target="_blank" title="MySQL扫盲 -- 授权方式">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>扫盲 -- <em>授权</em>方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1480</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/swotcoder/article/details/18518" target="_blank" title="MySQL扫盲 -- 授权方式">
				<span class="desc oneline">MySQL扫盲--授权方式作者：王猛(HeartIcy@163.com)很多人都不理解MySQL的授权方式，主要原因是没有中文资料别无其他！我不想嘲笑谁，但是我认为有必要搞清楚这一重要的因素。国际官司...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/swotcoder">来自：	<span class="blog_title"> swotcoder的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zsjangel/article/details/39644053","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zsjangel/article/details/39644053","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zsjangel/article/details/39644053" target="_blank" title="MySQL新增用户以及数据库访问授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>新增用户以及数据库访问<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-28</span>
				<span class="read-num hover-hide">
					阅读数 
					9663</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zsjangel/article/details/39644053" target="_blank" title="MySQL新增用户以及数据库访问授权">
				<span class="desc oneline">#mysql-uroot-p#允许本地IP访问localhost,127.0.0.1#insertintomysql.user(Host,User,Password)values('localhost...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zsjangel">来自：	<span class="blog_title"> 蜗牛的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/shamusoft/article/details/84510936","strategy":"BlogCommendFromAutoMl2","index":"47"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/shamusoft/article/details/84510936","strategy":"BlogCommendFromAutoMl2","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shamusoft/article/details/84510936" target="_blank" title="Windows 64位操作系统安装mysql 绿色版">
		<h4 class="text-truncate oneline">
				Windows 64位操作系统安装<em>mysql</em> 绿色版		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-10</span>
				<span class="read-num hover-hide">
					阅读数 
					28</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shamusoft/article/details/84510936" target="_blank" title="Windows 64位操作系统安装mysql 绿色版">
				<span class="desc oneline">1.先进行mysql-5.6.15-winx64.zip绿色版文件进行解压2.配置ini文件#Foradviceonhowtochangesettingspleasesee#http://dev.my...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shamusoft">来自：	<span class="blog_title"> 蜗行窝素</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/pf1234321/article/details/85115494","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/pf1234321/article/details/85115494","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/pf1234321/article/details/85115494" target="_blank" title="mysql MYSQL远程访问 授权IP">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>MYSQL</em>远程访问 <em>授权</em>IP		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-20</span>
				<span class="read-num hover-hide">
					阅读数 
					231</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/pf1234321/article/details/85115494" target="_blank" title="mysql MYSQL远程访问 授权IP">
				<span class="desc oneline">登陆在本机上使用命令行登陆,并切换到mysql库mysql-uroot-pusemysql;更改权限使用grantallprivilegeson来更改用户对应某些库的远程权限语法模板grantallp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/pf1234321">来自：	<span class="blog_title"> pf1234321的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010045996/article/details/84063018","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010045996/article/details/84063018","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010045996/article/details/84063018" target="_blank" title="mysql授权远程任意人登录">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>远程任意人登录		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					471</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010045996/article/details/84063018" target="_blank" title="mysql授权远程任意人登录">
				<span class="desc oneline">执行命令： GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'你的密码'WITHGRANTOPTION;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010045996">来自：	<span class="blog_title"> u010045996的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtzaEgwsNTMtZWR1.html" target="_blank">
                        华为授权云计算培训机构</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtzaEg2sMTktZWR1.html" target="_blank">
                        java易班请求授权</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/qq_26710805">
              <img src="https://avatar.csdn.net/B/8/9/3_qq_26710805.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/4.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/qq_26710805"  class="" id="uid">EchoShelter</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="41">
                        <dt><a href="https://blog.csdn.net/qq_26710805?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/qq_26710805?t=1"><span class="count">41</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="6">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">6</span></dd>
        </dl>
        <dl class="text-center" title="9">
            <dt>喜欢</dt>
            <dd><span class="count">9</span></dd>
        </dl>
        <dl class="text-center" title="8">
            <dt>评论</dt>
            <dd><span class="count">8</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="4级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-4"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="126922">
                12万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="1265">
                1265            </dd>
        </dl>
        <dl title="58949">
            <dt>排名：</dt>
            <dd>5万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/qq_26710805">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_26710805/article/details/83241979" target="_blank" >
                                        Java过滤文件名                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_26710805/article/details/82833083" target="_blank" >
                                        RandomAccessFile文件随机读写                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_26710805/article/details/81989811" target="_blank" >
                                        Gradle编译设置编码格式                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_26710805/article/details/81989783" target="_blank" >
                                        sar命令查看网卡流量                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_26710805/article/details/81591134" target="_blank" >
                                        SUSE(SLES 11 SP3)防火墙设置                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580079">
                    <span class="title oneline">开发工具</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7543503">
                    <span class="title oneline">--------Eclipse</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7662347">
                    <span class="title oneline">--------Git</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7965109">
                    <span class="title oneline">--------Gradle</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580092">
                    <span class="title oneline">操作系统</span>
                    <span class="count float-right">13篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7150518">
                    <span class="title oneline">--------Linux</span>
                    <span class="count float-right">12篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7572610">
                    <span class="title oneline">--------MSOffice</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580104">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7227230">
                    <span class="title oneline">--------MySQL</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7242186">
                    <span class="title oneline">--------Oracle</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7242123">
                    <span class="title oneline">--------PostgreSQL</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7559211">
                    <span class="title oneline">--------Redis</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580109">
                    <span class="title oneline">Java</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/8081182">
                    <span class="title oneline">--------Java IO</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7576186">
                    <span class="title oneline">--------Java基础</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7240833">
                    <span class="title oneline">--------Servlet</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580110">
                    <span class="title oneline">B端技术</span>
                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7624268">
                    <span class="title oneline">--------EasyUI</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7624301">
                    <span class="title oneline">--------JavaScript</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7101872">
                    <span class="title oneline">--------OpenLayers 2</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/6778075">
                    <span class="title oneline">设计模式</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7572694">
                    <span class="title oneline">数据挖掘</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580107">
                    <span class="title oneline">技术总结</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7216628">
                    <span class="title oneline">--------ElasticSearch</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7557400">
                    <span class="title oneline">--------Hadoop</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7558012">
                    <span class="title oneline">--------HBase</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7296221">
                    <span class="title oneline">--------Maven</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7576728">
                    <span class="title oneline">--------MyBatis</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7543555">
                    <span class="title oneline">--------SSM框架</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7580165">
                    <span class="title oneline">读书笔记❤</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_26710805/article/category/7730191">
                    <span class="title oneline">--------2018</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/10">
                    2018年10月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/09">
                    2018年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/08">
                    2018年8月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/07">
                    2018年7月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/06">
                    2018年6月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/05">
                    2018年5月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/04">
                    2018年4月                    <span class="count float-right">17篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2018/03">
                    2018年3月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2017/11">
                    2017年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2017/10">
                    2017年10月                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2017/09">
                    2017年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2017/08">
                    2017年8月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_26710805/article/month/2017/03">
                    2017年3月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/qq_26710805/article/details/80674006" >
                                                git命令总结记录                    </a>
					<p class="read">阅读数 <span>50227</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_26710805/article/details/79871730" >
                                                List集合取交集、并集、去除重复数据等                    </a>
					<p class="read">阅读数 <span>12702</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_26710805/article/details/79977148" >
                                                java读取src路径下的文件                    </a>
					<p class="read">阅读数 <span>9075</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_26710805/article/details/79776897" >
                                                Mysql授权远程登陆                    </a>
					<p class="read">阅读数 <span>9011</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_26710805/article/details/79855226" >
                                                Jaccard系数与Jaccard距离                    </a>
					<p class="read">阅读数 <span>5358</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_26710805/article/details/80101872#comments">easyUI通过JS在Dialog...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_39365424" class="user-name" target="_blank">qq_39365424：</a>我调用的html页面datagrid加载的数据出不来，已经查出来了，弹出框不显示？？                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_26710805/article/details/80674006#comments">git命令总结记录</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/MACHENIC" class="user-name" target="_blank">MACHENIC：</a>查不到别的分支啊。。。老哥                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_26710805/article/details/79855226#comments">Jaccard系数与Jaccard...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_39417323" class="user-name" target="_blank">weixin_39417323：</a>很直白了                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_26710805/article/details/79871730#comments">List集合取交集、并集、去除重复...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/fanrenxiang" class="user-name" target="_blank">fanrenxiang：</a>5.List中数据为对象，而不是基本数据类型 
那如果，两个list里面的泛型不一致呢？泛型对象里面有一些数据相同，这个如何？                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_26710805/article/details/79855226#comments">Jaccard系数与Jaccard...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_44736351" class="user-name" target="_blank">weixin_44736351：</a>例子中的相似度应该是为0吧，而不是1/3吧                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">2</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/qq_26710805/article/details/79720120" title="SSM框架整合（已测试通过）">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/qq_26710805/article/details/79777111" title="Stanford 中文分词">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/qq_26710805/article/details/79720120" title="SSM框架整合（已测试通过）">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/qq_26710805/article/details/79777111" title="Stanford 中文分词">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "79776897";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/qq_26710805/article/details/79776897";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "Mysql授权远程登陆 - Shelter";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u6388\u6743","\u8fdc\u7a0b\u767b\u9646"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
